IMG
Loading..
Select a color
Women's Lightweight Excel FR Comfortouch Premium Coverall
Item: 4BW-CLB3
Brand: Bulwark FR

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
Fabric: Westex Ultrasoft® Flame-resistant, 7 oz. (235 g/m2) 88% Cotton / 12% Nylon, Care: Home Wash, Light Soil Wash and Industrial Wash. Protection: Arc Rating ATPV 8.6 calories/cm2. Two-way concealed Nomex® taped brass break-away zipper, concealed snap at top of zipper and at neck. Mandarin style stand-up, two-way safety collar. Concealed snap closure on sleeve cuff. Elastic waist inserts. Two front swing pockets are topstitched and lined. Two patch chest pockets with flaps and concealed snap closure. Two patch hip pockets have single concealed snap closure. Left sleeve pocket. Deep-pleated action back. Side vent openings with snap closure. Rule pocket on right leg.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '4BW-CLB3') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`